Table: Billing Worksheet Customer

Table: PMBWC
View: PM0083
Record length: 345
Flags: A R 

Keys: 3

Title  Flags  Fields
Worksheet Number   SEQ, LINENUM
Detail Number   WORKID, CUSTLINE
Customer Number   D M  WORKID, CUSTOMER

Fields: 33

Field  Type  Title  Presentation 
SEQ  Long  Sequence   
LINENUM  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
WORKID  String*30  Worksheet Number  Mask: %-16C
CUSTLINE  Long  Customer Line Number   
CUSTOMER  String*12  Customer  Mask: %-12C
NAMECUST  String*60  Customer Name   
BILSTATUS  Integer  Status  List: 2 entries
1=Invoice
2=Hold
BILAMTSR  BCD*10.3  Document Amount   
BILAMTHM  BCD*10.3  Document Amount   
RATE  BCD*8.7  Exchange Rate   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator  List: 2 entries
1=Multiply
2=Divide
PONUMBER  String*22  P/O Number  Mask: %-22C
CURRENCY  String*3  Currency  Mask: %-3N
TEXTOPFL1  String*2  Reserved   
TEXTOPFL2  String*3  Reserved   
TEXTOPFL3  String*4  Reserved   
TEXTOPFL4  String*12  Reserved   
TEXTOPFL5  String*15  Reserved   
TEXTOPFL6  String*30  Reserved   
OPFLDATE  Date  Reserved   
OPFLAMT  BCD*10.3  Reserved   
RATESPREAD  BCD*8.7  RATESPREAD   
RETRATE  Integer  RETRATE  List: 2 entries
1=Use Original Document Exchange Rate
2=Use Current Exchange Rate
CONTRACT  String*16  Contract  Mask: %-16C
FMTCONTNO  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
NUMDTL  Long  NUMDTL   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.